I have an SQL table with an id column that uses auto-increment. When I delete a row (e.g., where the id is 6), the IDs of the remaining rows do not change, and there is no longer a row with id 6. How can I automatically rearrange the IDs of the remaining rows so they are continuous (e.g., 1, 2, 3, … without gaps) after a deletion?