I'd suggest using a third table for 'modelcolor'. Remove the colorid column from your model table and create a third table along these lines
id modelid colorid
1 67 8
2 67 9
You can now query like so...
SELECT
modelid, modelno, colorname
FROM
Model m
INNER JOIN
ModelColor mc ON M.modelid = MC.modelid
INNER JOIN
Color C ON MC.colorid = C.colorID
Your data is now normalised and this SQL will return all the models and possible color options