create table foo (
   id    numeric(9) identity,
    ....
)
with identity_gap = 1