Method of production of a mineral foam obtained from a foaming slurry of high yield stress