添加到变量的SQL ROW_NUMBER

I have a table that has a unique ID column which is an int. This doesn't necessarily contain all numbers up to the maximum, some are missed out (it isn't an identity column - out of my control).I have a table that has a unique ID column whic