title: Changing default sorting behavior of mysql
body: <p>I have a table in my database.</p>
  
  <pre><code>+--------+-------------+------+-----+---------+----------------+
  | 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    |                |
  +--------+-------------+------+-----+---------+----------------+
  </code></pre>
  
  <p>By default if I query</p>
  
  <pre><code>select * from students;
  </code></pre>
  
  <p>Shows result sorted by <code>id INT (auto-increment)</code>.</p>
  
  <pre><code>+----+--------+------------+-------+
  | 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)
  </code></pre>
  
  <p>I want to change default sorting behaviour and make <code>rollno</code> the default sorting field, how do I do this?</p>