Use the next possible primary key on auto_increment column after deleting one or more row
===

I have a table with a primary key, auto_increment ID column. When I delete the row with the highest ID, for instance ID 100, I want to use that ID 100 for a new row only using a mysql trigger. How do I do that?

*When I delete, for instance ID 1 AND the highest ID is 100, I don't want to use ID 1 again.*

