Rainbows are one of nature’s grand spectacles. How careful, then, have painters been to get their colours in the ‘right’ order?