How to number fields in a rule in MYSQL?

Question

MySQL

There are lines, they need to be numbered: first, last, second, penultimate, third, penultimate and so on
Example:
1
3
5
7
6
4
2

How to do this?

Answer 1

Cycle from the last element to the first, alternately adding each subsequent element to the beginning of the resulting list, then to the end (in this case, the first action is determined depending on the parity of the total number of elements.

Answer 2

You know the number of elements in the array, iterate each element and assign Count() - n, where n is the current iteration. Well and to do it certainly not means SQL.