mysql> select * from test;
+------+
| id   |
+------+
| pash | 
| ke   | 
| la   | 
+------+
3 rows in set (0,00 sec)

mysql> select (select id from (select id from test order by id asc limit 1) as a order by id desc limit 1);
+----------------------------------------------------------------------------------------------+
| (select id from (select id from test order by id asc limit 1) as a order by id desc limit 1) |
+----------------------------------------------------------------------------------------------+
| ke                                                                                           | 
+----------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)

mysql> select (select id from (select id from test order by id asc limit 2) as a order by id desc limit 1);
+----------------------------------------------------------------------------------------------+
| (select id from (select id from test order by id asc limit 2) as a order by id desc limit 1) |
+----------------------------------------------------------------------------------------------+
| la                                                                                           | 
+----------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)