Maybe you can also select the accountid column for sorting.
SELECT accountid,concat('test_',ACCOUNTID) from table order by accountid;
Or, rename "concat('test_', accountid) " as accountid, like this:
SELECT concat('test_',ACCOUNTID) accountid from table order by accountid;