You still might benefit from adding an InsertedDate column to that table, so that you can use ORDER BY InsertedDate ASC as the ORDER BY clause in your ROW_NUMBER() function, as that would be more likely to result in the correct order.   Using the same column as the partition by will NOT guarantee that you get the order correct.