UPDATE routes SET route_id=vtable.rn
FROM
(
SELECT row_number() over() as rn, route_id from routes
) AS vtable
WHERE routes.route_id = vtable.route_id;