I think by "application level" they are saying "using transactions at the application level". If you require a strict sequence of numbers then you BEGIN, READ,

I think by "application level" they are saying "using transactions at the application level". If you require a strict sequence of numbers then you BEGIN, READ, INSERT, COMMIT, that is really what you want so just do it explicitly. If the COMMIT fails because of a duplicate key then you start over.