<p>Sequence is currently alphabetic, therefore '10' comes before '2'. If you want the sequence numeric, you'll need to change the titles to '001' '002' ... '200' or add leading spaces, ' 1', ' 2' ... '200'</p>
<p>The author/song sequence isn't quite as straightforward as you make out, we're not issuing SQL statements directly, rather using a data abstraction layer. Also sqlite struggles sorting some unicode dialects.</p>