set @rownum := 0;
UPDATE tablex as t
SET t.order_by = @rownum := @rownum + 1
order by t.order_by

SQLFiddle示例