The fugitive suspect behind a deadly van and machete attack near Berlin's Christopher Street Day Pride celebrations has been shot dead by police after a manhunt.