How do I find second highest value from a table?

<?php 

$query = mysql_query("SELECT number FROM table ORDER BY number DESC LIMIT 2"); 
$second_highest = mysql_result($query,1,0); 
echo "the answer to your question is $second_highest"; 
?>