set @n:= 0 ;
select @n:=@n+ 1  as rownum, l.* from languages l;

rownum  lang_id  lang_name   lang_status
------  -------  ----------  -----------
     1        1  Русский               1
     2       13  Английский            1

drop table if exists t1;

create table t1 (
 id int not null auto_increment primary key,
 t_1 int not null,
 t_2 int not null);

insert into t1 (t_1, t_2) values ( 5 , 6 ), ( 13 , 2 ), ( 6 , 3 ), ( 9 , 4 );

( 0  row(s) affected)
( 0  ms taken)

( 0  row(s) affected)
( 0  ms taken)

( 4  row(s) affected)
( 0  ms taken)

select * from t1

    id     t_1   t_2  
------  ------  ------
     1       5       6
     2      13       2
     3       6       3
     4       9       4

set @n:= 0 ;
select @n:=@n+ 1  as rownum, t1.* from t1 order by t_1 desc;

rownum      id      t_1    t_2  
------  ------  ------  ------
     1       2      13       2
     2       4       9       4
     3       3       6       3
     4       1       5       6