Numerical approximation of the stochastic Cahn–Hilliard equation near the sharp interface limit