> If you need a consecutive number for a particular reason, I would then
> NOT use it as the primary key, i.e. just have a second column/field

for it.

no, that's not the point.
i was only thinking that at some stage i may run out of id's...