@Robert_James I just wanted to add another warning to what what @levijustus said.
Using the command ‘truncate tablename’ deletes all the data in that table in addition to resetting the auto increment fields. I’m not sure if the previous post gives a serious enough warning about the use of the command.
Also, many of of the ID fields are use by other tables to establish a relationship between the data of the two tables. Changing or reordering the ID’s can have serious consequences.
Unless you have specific knowledge of all that will happen if you do reorder the id’s, I wouldn’t change them.