How can pixels generate a color image?

They fool your eyes - really your brain.

Note that you don't see color, you detect frequency distributions (rods and cones of the retina)

which your brain translates into colors for you.