NHS Confederation chief accuses Government of ‘magical thinking’ and says ‘it’s going to be really tough’ to deliver reform