select
  S.ID AS ID_S
  , S.SIZE AS SZ
  , C.ID AS ID_C
  , C.COLOR AS CL
from
  TBL_SIZE AS S
cross join
  TBL_COLOR AS C
where
  ID_S in (1, 3)
order by
  S.ID desc
  , C.ID desc
;