Al-Qaeda mastermind Osama bin Laden has been killed in a US operation in Pakistan, President Barack Obama says.