[etc]

insert into table (y, z) select (select max(y) + 1 from table), 1234;