mysql limit 倒序_SELECT...LIMIT查询出的结果是倒序的了

为何我用SELECT...LIMIT查询出的结果是倒序的？从尾部开始计算顺序的呢？  提前谢谢高手解惑，谢谢：

mysql> SELECT * FROM id4;

+----+-------+------+

| id | name  | sex  |

+----+-------+------+

|  1 | Diego | UN   |

|  2 | Sam   | M    |

|  3 | Tom   | F    |

|  4 | Mark  | UN   |

|  5 | Kim   | UN   |

|  6 | Kate  | F    |

|  7 | Rose  | F    |

|  8 | Joe   | UN   |

+----+-------+------+

8 rows in set (0.00 sec)

mysql> SELECT id,name FROM id4 LIMIT 2,3;

+----+------+

| id | name |

+----+------+

|  6 | Kate |

|  5 | Kim  |

|  4 | Mark |

+----+------+

3 rows in set (0.00 sec)

mysql> SELECT id,name FROM id4 LIMIT 2;

+----+-------+

| id | name  |

+----+-------+

|  1 | Diego |

|  8 | Joe   |

+----+-------+

2 rows in set (0.00 sec)