Sort table rows and save the row numbers using UPDATE
Join to a subquery that computes numero with the window function row_number():

UPDATE movimientos m
SET    numero = sub.rn
FROM  (SELECT id, row_number() OVER (ORDER BY orden, id) AS rn FROM movimientos) sub
WHERE  m.id = sub.id;


Details for UPDATE syntax in the manual.

If you have concurrent write access you need to lock the table to avoid race conditions.

Note that updating every row in a table is expensive either way. The table typically grows to twice its size and VACUUM or VACUUM FULL may be in order. 

Depending on your complete situation it may be more efficient to write a new table to begin with. Related answers with instructions:


Best way to populate a new column in a large table?
Optimizing bulk update performance in PostgreSQL


I am not convinced, though, that you need the column numero in your table at all. Maybe you are looking for a MATERIALIZED VIEW. Recent related answer on SO:


Global row numbers in chunked query