使用SQL串联与ORDER BY

I'm confused. How could you explain this diffenece in variable concatenation with ORDER BY? I'm confused. How could you explain this diffen