title: How to order the numbers?
body: <p>Table1</p>
  
  <pre><code>id value
  ---------    
   1  100
  2A  200
   2  300
  10  500
   8  200
  ....
  
  Select * 
  from table1 
  order by id
  </code></pre>
  
  <p>Showing output as</p>
  
  <pre><code>id value
  ------------    
   1 100
  10 500
  2A 200
   2 300
   8 200
  ....
  </code></pre>
  
  <p>How to make a proper order?</p>
  
  <p>Expected output</p>
  
  <pre><code>id value
  ----------
   1 100
   2 300
  2A 200
   8 200
  10 500
  ....
  </code></pre>