Is there a way I can get my query to order results via the last 3 digits in the number but in an order resembling “000, 010, 020, 030, 050, 060, 070, 080, 090, 001, 011, 021, 031, 041, 051, 061, 071, 081, 091, 002, 012, 022, 032” etc?

Order by
((cast(right(column name, 3) as int / 10) * 10), column name;

This just seems to order it randomly instead of in the order I’m looking for.