How can I do a select in a table and get a field that has the order of
the register in the result ?

Ex:

select Order, order_id from orders order by date

my result:

order_id,
1
5
3

What I want:

|-----------------------------------|
| Order(Position) | order_id |
|-----------------------------------|
| 1 | 1 |
| 2 | 5 |
| 3 | 3 |
|-----------------------------------|

Ronaldo Rezende.