Royal Fleet Auxiliary sailors have overwhelmingly voted to accept an improved pay offer from the Ministry of Defence, bringing an end to a prolonged dispute.