alpha numeric sorting using mysql query

I have several product ids. Here are some examples:

c-05开发者_高级运维 , C-1025 , C-1035 , C-155 , C1B , k-1202

I have to sort these ones in ascending order.

I've tried with an ORDER BY clause with ascendent direction, but doesn't achieve what I need.

Any proposal?