President Biden honored Carter’s ‘character’ during his eulogy as Trump, Obama and other former presidents attended the service at the Washington National Cathedral