SELECT row_number() OVER()
FROM ....... ORDER BY id; 

7
1
2
3
4
5
6
8
9
10
11
12
13
14
15
16

SELECT row_number() OVER(ORDER BY id)
FROM ....... ORDER BY id;