The Duke of Edinburgh's final public engagement before he retires at the age of 96 will take place on August 2, Buckingham Palace has said.