Sri Lankan President Gotabaya Rajapaksa has confirmed he will resign, the prime minister's office has said after tens of thousands of protesters stormed the official residences of both men.