Neben der IDENTITY gäbe es auch SEQUENCE

CREATE SEQUENCE MySeq
START WITH 1
INCREMENT BY 1
MAXVALUE 10000
CYCLE

VALUES (NEXT VALUE FOR MySeq)