‘Accept and respect one another regardless of changing values’, MSPs told