请尝试以下查询以按您预期的顺序获得结果.

Try following query to get the results in your expected order.

小提琴演示

Select product_id
From tbl              --Please change table name to #tbl in your actual query
Order by len(product_id), product_id