As I understood you need something like this (I named your table airports and assumed that you have exactly 150 rows in your table):
select b.Description, b.ShortDescription,
ROW_NUMBER() OVER(order by shortdescription desc) +49 AS 'ID'
from airports b
If you need modifications please express more details for me to provide another solution ;)