Is there a simple way to keep MySQL row ids from growing?

[Ourojmacnl]

I was wondering what the simplest way of letting a table set ids automatically is, apart from AUTO_INCREMENT.I have a table that will accumulate thousands of rows over a long period of time. Some of these rows will be deleted at a later time. How do I get new rows to get the lowest available id, without getting into doing it manually.Can I for instance reset AUTO_INCREMENT every time someone adds a row?