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