The auto increment of a table is not counting continuously in any case. For example create a table:
Then insert some rows:
After that the added rows have the correct ID, but the auto_increment of the table is not 5 but 8.
Running the statement again:
Leads to the following table:
And the auto_increment of the table is 15.