Dust traps and the formation of cavities in transition discs: a millimetre to sub-millimetre comparison survey