fetch mysql information based on column value
===

Is there a way to run a mysql $query and specify and order by the value within a column. so if you have a table with column:name, and there are 2 people with the name 'john' but the first john has 'id':10  and the second john has 'id':20. I want to echo the first john(10) first. so something like:

      $sql = mysql_query("SELECT firstname FROM users 
                       WHERE email='$email' 
                       AND id='(*smallest value*)'");

      while($info = mysql_fetch_assoc($sql))
      echo $info['firstname']