I want to order the entries in my table and they will be reordered by the user later so I don't want to use the ID. I have just added the :order column and the values are currently all nil. I know I can give them all the same value using update\_all but how can I give each row a value one higher than the last (e.g. 1,2,3,4,5,6 etc)?

I am using rails 3.2.