David, your suggestion is very helpful where records could be imported from another source, with their own unique ids.

What would happen if a record with an ID of 500 were imported, but the sequence was only up to, say, 450?