Raman spectroscopy of metals, high‐temperature superconductors and related materials under high pressure