Suggestions on converting SQL varchar as number

I have a Mariadb table with a varchar field. I’m having trouble sorting it. I’m sure this has to do with the varchar status but I don’t know what is the best way to convert it during the API database pull.

Any suggestions and guidance is appreciated…