ORDER BY ColumnName vs ORDER BY ColumnNumber

Pinal Dave in his blog posted this about using a column name and column number in the Order by clause. He made some valid points on why the second method should not be used. However, there is a case in which second method can be useful I had already blogged...