The query you have written will not throw an error but in some cases this query can throw error. This query will give all the records which is in sorting order in respect of the column 1.

Suppose you have written query like this:
Select ProductId , ProductName from ProductMaster order by 3

In that case this query will throw error because there is only two column in the table an we want to order the result by the third column.