Surface‐enhanced resonance Raman and hyper‐Raman spectroscopy of water‐soluble substituted stilbene and distyrylbenzene chromophores