The number of completed housing transactions, a key indicator of future big-ticket home spend, remained positive in June as rises in England, Wales and Northern Ireland mitigated a slower property market in Scotland.