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