Code To Simulate OP's Table:
CREATE TABLE customer (C_recid INT);
INSERT INTO customer VALUES (50200),(50194),(50430),(50191),(1);
Here is my solution:
DECLARE @Lookup TABLE (C_recid INT, OrderSeq SMALLINT);
INSERT INTO @Lookup VALUES (50200, 1), (50194, 2), (50430, 3), (50191, 4), (1, 5);
SELECT
c.*
FROM
customer c
INNER JOIN
@Lookup l
ON c.C_recid = l.C_recid
ORDER BY
l.OrderSeq;