PM Rishi Sunak should not go back on his pledge to re-join the EU's science research programme, the President of The Royal Society has warned.