SELECT
    ts.ID AS ID_S,
    SIZE AS SZ,
    tc.ID AS ID_C,
    COLOR AS CL
FROM
    TBL_SIZE as ts
CROSS JOIN
    TBL_COLOR as tc
WHERE
    ts.ID IN (1, 3)
ORDER BY
    ID_S DESC, ID_C DESC;