Is there a way to SELECT from a table so that I can specify the prefix and constrain the "%" to only numbers

So like if I have

```
column
------
abc123
abc124
abc0023
abcdef

```

If I do like `SELECT * FROM TABLE WHERE column LIKE 'abc%'` then it finds all of them.

I want to only the ones with the numeric suffix. And in fact I really want the MAX() of that if it matters.

The prefix may be any length string.