begin;
select id_order from tablename where /**/ order by id_order limit 1 for update
insert ...
commit;