mysql 去掉默认排序_更改MySQL的默认排序行为

我的数据库中有一个表.

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

| Field | Type | Null | Key | Default | Extra |

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

| id | int(11) | NO | PRI | NULL | auto_increment |

| rollno | int(11) | NO | | NULL | |

| name | varchar(20) | NO | | NULL | |

| marks | int(11) | NO | | NULL | |

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

默认情况下,如果我查询

select * from students;

显示按ID INT(自动递增)排序的结果.

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

| id | rollno | name | marks |

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

| 1 | 65 | John Doe | 89 |

| 2 | 62 | John Skeet | 76 |

| 3 | 33 | Mike Ross | 78 |

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

3 rows in set (0.00 sec)

我想更改默认的排序行为并使rollno成为默认的排序字段,我该怎么做？