CREATE SEQUENCE seq_mitarbeiterid
    INCREMENT BY 1
    START WITH 0
    MAX VALUE 9999
    NOCACHE
    NOCYCLE;

CREATE SEQUENCE seq_mitarbeiterid
INCREMENT BY 1
START WITH 0
MAXVALUE 9999    -- Here
NOCACHE
NOCYCLE;

create table t (
    t_id int auto_increment primary key,
    . . .
);