Asymptotic Poisson character of extremes in non-stationary Gaussian model and statistical applications