WITH ... UPDATE

SQL

WITH a as (SELECT id, row_number() OVER() rn FROM camera)
UPDATE camera SET id = (SELECT rn FROM a WHERE camera.id = a.id);