A gunman suspected of killing six people including a British national in Krakow on Saturday has died in hospital.