How to fill in the table correctly?

Question

MySQL

There is a table
joxi.ru/8An6qjRsjDvMqA
id auto_increment
When manipulating on the site, I delete the line with id=9
Is there such a possibility in MYSQL that the next time data is added to this database, the data would be in line =9 ? Next at 11, 12, 13, etc.
Well, that is, there was a correct filling in the database, so that there would be an order of 1,2,3,4, etc.
And then it turns out 1,2,5,6,7,10,11, etc.

Answer 1

AUTO_INCREMENT only guarantees that the id of the next inserted row will be greater than the id of any other row in the table. Lacunae when deleting lines and unsuccessful inserts is a completely normal situation, there is no point in fighting it.