Interaction of a cold cloud with a hot wind: the regimes of cloud growth and destruction and the impact of magnetic fields