Super-eruptions: global effects and future threats