Assuming you have a status table that contains all the provided status. You can add a column in that status table named ORDERING_INFO.
ALTER TABLE STATUS ADD ORDERING_INFO INT NULL
UPDATE STATUS SET ORDERING_INFO = 2 WHERE STATUS_ID = 1;
UPDATE STATUS SET ORDERING_INFO = 1 WHERE STATUS_ID = 2;
UPDATE STATUS SET ORDERING_INFO = 4 WHERE STATUS_ID = 3;
UPDATE STATUS SET ORDERING_INFO = 3 WHERE STATUS_ID = 4;
You can then modify your select query like this
SELECT ID,NAME
FROM TABLE
INNER JOIN STATUS ON TABLE.STATUS = STATUS.STATUS_ID
ORDER BY STATUS.ORDERING_INFO