oracle update table order by old_id

update (select * from mytable order by old_id) set new_id = mysequence.nextval;