Statistics of Colliding-wind binaries as non-thermal X-ray emitters: an observational investigation from XMM-Newton to next generation X-ray observatories