The majority of advisers are concerned about losing assets in the 'great wealth transfer' when trillions of pounds are expected to be handed down to future generations.