how "holes" table

i recently hereditary database tables primary pivotal stoical encoded values (part1*1000 + part2).

i normalized column, nonetheless i can't change aged values.
so i have

select id list method id
id
100001
100002
101001
...

i wish "holes" list (more precisely, initial "hole" after 100000) new rows.

i'm controlling following select, nonetheless there improved proceed that?

select /* tip 1 */ id+1 newid table
where id > 100000 and
id + 1 (select id table)
order id

newid
100003
101029
...

the database microsoft sql server 2000. i'm ok controlling sql extensions.