This question comes frequently but it's a false problem. You don't have to care about id. It's just an identifier. Leave it as it is.
You can add a progressive number programmatically, using your favourite programming language or via sql.
select *,@row:=@row+1 as progressive_number
from table, (select @row:=0) as t
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…