[C0oL3r]

Hello, is any method to rearrange the ID of a table, like i have a house system and i create a wrong house, i delete him from the database where his id were 1 and if i create a new house it will be 2, how can i make that id to be 1 or whatever number is the succesive of the last id created

And if are much houses, when i remove a house can i rearrange all to have succesive id's?