6d (1,0) SCFTs and their compactifications: a holographic approach