SQL SERVER 2014 - SELECT INTO, ORDER BY - automatic clustered index?
No, the ORDER BY applies to the SELECT query and not to the table created by SELECT INTO.
Using ORDER BY is unnecessary in this statement, because it doesn't even guarantee the rows are inserted into the new table in that order.
See INTO Clause (Transact-SQL)