Never change the numbers of the first row firebird base libreoffice

I AM USING LIBREOFFICE BASE WITH FIREBIRD MOTOR
I have a query where the names of the planets are sorted in ascending order (ASC)

my problem is that when changing the ascending or descending order of the first column that uses a ROW_NUMBER the numbering of the first column always changes, it is logical.

But I want that no matter how I order the other columns I wish that the first column NEVER CHANGE ORDER, THAT THE FIRST ROW AND FIRST COLUMN ALWAYS BE “1” THE SECOND ROW AND FIRST COLUMN ALWAYS BE “2”, THE THIRD ROW AND FIRST COLUMN ALWAYS BE “3” and so on.

I think this attached image says it all and I also attach the database 15719441156728005.odb
image descriptionimage description

Hello,

Just put the query in sequence wanted first then apply the sequence #:

Top is ascending and lower is descending.

Possibly other methods such as How to get record number or rank as part of dataset?
Just tried to get you a quick answer here.

Again, refer to Firebird documentation.