Sales of magnesium supplements are surging. Trials have shown promising results in improving sleep and easing migraines. But not everyone will feel the benefits